package com.darren.euc.dao.impl;


import java.util.List;

import org.hibernate.Session;
import org.springframework.stereotype.Repository;

import com.darren.euc.dao.ClientLevelDao;
import com.darren.euc.entity.ClientLevel;


@Repository
public class ClientLevelDaoImpl extends BaseDaoImpl<ClientLevel, Integer> implements ClientLevelDao {
	
	@SuppressWarnings("unchecked")
	@Override
	public List<ClientLevel> getAll() {
		Session session = sessionFactory.getCurrentSession();	
		return session.createSQLQuery("select * from euc_client_level where enable='1' order by display_sequence asc,convert(client_level_name using gbk) asc;").addEntity(ClientLevel.class).list();
	}


}